CREATE TABLE [dbo].[SLOP]
(
[AssetID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FacilityAndAssetID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Issuer_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Facility_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Facility_SecurityID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_LOANXAssetID_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Portfolio_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Portfolio_AbbrevName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_CUSIPAssetIDType_ID] [float] NULL,
[Asset_CUSIPAssetIDType_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_BL Dummy CUSIPAssetID_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_BL Dummy CUSIPAssetIDType_ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Asset_CUSIPAssetID_Name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Position_ID] [float] NULL,
[CommitmentTraded] [float] NULL,
[@AsOfDate] [datetime] NULL
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'VirtualFolder', N'SSB Stuff', 'SCHEMA', N'dbo', 'TABLE', N'SLOP', NULL, NULL
GO
